Skip to content

Instantly share code, notes, and snippets.

View adityadaniel's full-sized avatar
🛠️

Daniel Aditya Istyana adityadaniel

🛠️
View GitHub Profile
declare
v_fname employees.first_name%type;
v_lname employees.last_name%type;
begin
select first_name, last_name into v_fname, v_lname from employees where employee_id=1000;
dbms_output.put_line('Nama depannya adalah: ' || v_fname );
dbms_output.put_line('Nama belakangnya adalah: ' || v_lname );
exception
when no_data_found then
declare
i number(1);
Nama varchar2(100);
begin
<< outer_loop >>
select first_name into nama from employees where first_name = 'Den';
dbms_output.put_line('Nama adalah: ' || Nama );
for i in 1..3 loop
<< inner_loop >>
dbms_output.put_line('Nama saya berulang: ' || Nama );
Sub PasswordBreaker()
'Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
@adityadaniel
adityadaniel / add body class genesis.php
Created January 13, 2017 03:44
Add custom class to body in Genesis themes
// Add custom body class to the head
add_filter( 'body_class', 'uc_body_class' );
function add_body_class( $classes ) {
$classes[] = 'name-of-css-class-goes-here';
return $classes;
}
@adityadaniel
adityadaniel / textexpander_gen.rb
Last active October 29, 2022 23:44 — forked from ttscoff/textexpander_gen.rb
Mass generate TextExpander snippets from a CSV file. I modified the script to add label for the created snippets using the data from third column of the CSV file
#!/usr/bin/ruby
require 'csv'
require 'erb'
require 'cgi'
if ARGV.length == 2
input_csv = ARGV[0]
output_te = ARGV[1]
unless output_te =~ /\.textexpander$/
puts "Second argument must have a '.textexpander' extension."